#region Using directives
using System;
using System.Data;

using WP.Commons;
#endregion

namespace WP.MF.DataEntity
{

	/*
	 * Created by Z
	 * At  Monday, August 01, 2005
	 */

	//=========MBranch  ============================
	[System.ComponentModel.DesignerCategory("Code")]
    public class MBranchDEL : DataSet, IDataEntity
	{
		//=========MBranch ============================
		public const string TABLENAME_MBRANCH="MBranch";

		public const string RECID="RecId";
		public const string RECSTAMP="RecStamp";
		public const string BRANCHNO="BranchNo";
		public const string BRANCHDESC="BranchDesc";
		public const string STINVRANGE="StInvRange";
		public const string ENINVRANGE="EnInvRange";
		public const string NEXTINVNO="NextInvNo";
		public const string STORDRANGE="StOrdRange";
		public const string ENORDRANGE="EnOrdRange";
		public const string NEXTORDNO="NextOrdNo";
		public const string STPURCHORDRANGE="StPurchOrdRange";
		public const string ENPURCHORDRANGE="EnPurchOrdRange";
		public const string NEXTPURCHORDNO="NextPurchOrdNo";
		public const string STWORKORDRANGE="StWorkOrdRange";
		public const string ENWORKORDRANGE="EnWorkOrdRange";
		public const string NEXTWORKORDNO="NextWorkOrdNo";
		public const string INTERBRNACCTNO="InterBrnAcctNo";
		public const string INTERBRNPROFITNO="InterBrnProfitNo";
		public const string STQUOTRANGE="StQuotRange";
		public const string ENQUOTRANGE="EnQuotRange";
		public const string NEXTQUOTNO="NextQuotNo";
		public const string INVACCTNO="InvAcctNo";
		public const string INVPROFITNO="InvProfitNo";
        public const string INVACCTNO1 = "InvAcctNo1";
        public const string INVPROFITNO1 = "InvProfitNo1";

		#region Not Used Fields
		/*
		public const string SALES01="Sales01";
		public const string SALES02="Sales02";
		public const string SALES03="Sales03";
		public const string SALES04="Sales04";
		public const string SALES05="Sales05";
		public const string SALES06="Sales06";
		public const string SALES07="Sales07";
		public const string SALES08="Sales08";
		public const string SALES09="Sales09";
		public const string SALES10="Sales10";
		public const string SALES11="Sales11";
		public const string SALES12="Sales12";
		public const string SALES13="Sales13";
		public const string COST01="Cost01";
		public const string COST02="Cost02";
		public const string COST03="Cost03";
		public const string COST04="Cost04";
		public const string COST05="Cost05";
		public const string COST06="Cost06";
		public const string COST07="Cost07";
		public const string COST08="Cost08";
		public const string COST09="Cost09";
		public const string COST10="Cost10";
		public const string COST11="Cost11";
		public const string COST12="Cost12";
		public const string COST13="Cost13";
		public const string PRYRSALES01="PrYrSales01";
		public const string PRYRSALES02="PrYrSales02";
		public const string PRYRSALES03="PrYrSales03";
		public const string PRYRSALES04="PrYrSales04";
		public const string PRYRSALES05="PrYrSales05";
		public const string PRYRSALES06="PrYrSales06";
		public const string PRYRSALES07="PrYrSales07";
		public const string PRYRSALES08="PrYrSales08";
		public const string PRYRSALES09="PrYrSales09";
		public const string PRYRSALES10="PrYrSales10";
		public const string PRYRSALES11="PrYrSales11";
		public const string PRYRSALES12="PrYrSales12";
		public const string PRYRCOST01="PrYrCost01";
		public const string PRYRCOST02="PrYrCost02";
		public const string PRYRCOST03="PrYrCost03";
		public const string PRYRCOST04="PrYrCost04";
		public const string PRYRCOST05="PrYrCost05";
		public const string PRYRCOST06="PrYrCost06";
		public const string PRYRCOST07="PrYrCost07";
		public const string PRYRCOST08="PrYrCost08";
		public const string PRYRCOST09="PrYrCost09";
		public const string PRYRCOST10="PrYrCost10";
		public const string PRYRCOST11="PrYrCost11";
		public const string PRYRCOST12="PrYrCost12";
		public const string PRPRYRSALES01="PrPrYrSales01";
		public const string PRPRYRSALES02="PrPrYrSales02";
		public const string PRPRYRSALES03="PrPrYrSales03";
		public const string PRPRYRSALES04="PrPrYrSales04";
		public const string PRPRYRSALES05="PrPrYrSales05";
		public const string PRPRYRSALES06="PrPrYrSales06";
		public const string PRPRYRSALES07="PrPrYrSales07";
		public const string PRPRYRSALES08="PrPrYrSales08";
		public const string PRPRYRSALES09="PrPrYrSales09";
		public const string PRPRYRSALES10="PrPrYrSales10";
		public const string PRPRYRSALES11="PrPrYrSales11";
		public const string PRPRYRSALES12="PrPrYrSales12";
		public const string PRPRYRCOST01="PrPrYrCost01";
		public const string PRPRYRCOST02="PrPrYrCost02";
		public const string PRPRYRCOST03="PrPrYrCost03";
		public const string PRPRYRCOST04="PrPrYrCost04";
		public const string PRPRYRCOST05="PrPrYrCost05";
		public const string PRPRYRCOST06="PrPrYrCost06";
		public const string PRPRYRCOST07="PrPrYrCost07";
		public const string PRPRYRCOST08="PrPrYrCost08";
		public const string PRPRYRCOST09="PrPrYrCost09";
		public const string PRPRYRCOST10="PrPrYrCost10";
		public const string PRPRYRCOST11="PrPrYrCost11";
		public const string PRPRYRCOST12="PrPrYrCost12";
		public const string PURCH01="Purch01";
		public const string PURCH02="Purch02";
		public const string PURCH03="Purch03";
		public const string PURCH04="Purch04";
		public const string PURCH05="Purch05";
		public const string PURCH06="Purch06";
		public const string PURCH07="Purch07";
		public const string PURCH08="Purch08";
		public const string PURCH09="Purch09";
		public const string PURCH10="Purch10";
		public const string PURCH11="Purch11";
		public const string PURCH12="Purch12";
		public const string PURCH13="Purch13";
		public const string PURCHDISC01="PurchDisc01";
		public const string PURCHDISC02="PurchDisc02";
		public const string PURCHDISC03="PurchDisc03";
		public const string PURCHDISC04="PurchDisc04";
		public const string PURCHDISC05="PurchDisc05";
		public const string PURCHDISC06="PurchDisc06";
		public const string PURCHDISC07="PurchDisc07";
		public const string PURCHDISC08="PurchDisc08";
		public const string PURCHDISC09="PurchDisc09";
		public const string PURCHDISC10="PurchDisc10";
		public const string PURCHDISC11="PurchDisc11";
		public const string PURCHDISC12="PurchDisc12";
		public const string PURCHDISC13="PurchDisc13";
		public const string PRYRPURCH01="PrYrPurch01";
		public const string PRYRPURCH02="PrYrPurch02";
		public const string PRYRPURCH03="PrYrPurch03";
		public const string PRYRPURCH04="PrYrPurch04";
		public const string PRYRPURCH05="PrYrPurch05";
		public const string PRYRPURCH06="PrYrPurch06";
		public const string PRYRPURCH07="PrYrPurch07";
		public const string PRYRPURCH08="PrYrPurch08";
		public const string PRYRPURCH09="PrYrPurch09";
		public const string PRYRPURCH10="PrYrPurch10";
		public const string PRYRPURCH11="PrYrPurch11";
		public const string PRYRPURCH12="PrYrPurch12";
		public const string PRYRPURCHDISC01="PrYrPurchDisc01";
		public const string PRYRPURCHDISC02="PrYrPurchDisc02";
		public const string PRYRPURCHDISC03="PrYrPurchDisc03";
		public const string PRYRPURCHDISC04="PrYrPurchDisc04";
		public const string PRYRPURCHDISC05="PrYrPurchDisc05";
		public const string PRYRPURCHDISC06="PrYrPurchDisc06";
		public const string PRYRPURCHDISC07="PrYrPurchDisc07";
		public const string PRYRPURCHDISC08="PrYrPurchDisc08";
		public const string PRYRPURCHDISC09="PrYrPurchDisc09";
		public const string PRYRPURCHDISC10="PrYrPurchDisc10";
		public const string PRYRPURCHDISC11="PrYrPurchDisc11";
		public const string PRYRPURCHDISC12="PrYrPurchDisc12";
		*/
		#endregion Not Used Fields
		public const string STREET="Street";
		public const string CITY="City";
		public const string PROVNO="ProvNo";
		public const string POSTALCODE="PostalCode";
		public const string FAX="Fax";
		public const string PHONE="Phone";
		public const string COMPANYPHONE01="CompanyPhone01";
		public const string COMPANYPHONE02="CompanyPhone02";
		#region Not Used Fields
		/*
		public const string MKTCOST01="MktCost01";
		public const string MKTCOST02="MktCost02";
		public const string MKTCOST03="MktCost03";
		public const string MKTCOST04="MktCost04";
		public const string MKTCOST05="MktCost05";
		public const string MKTCOST06="MktCost06";
		public const string MKTCOST07="MktCost07";
		public const string MKTCOST08="MktCost08";
		public const string MKTCOST09="MktCost09";
		public const string MKTCOST10="MktCost10";
		public const string MKTCOST11="MktCost11";
		public const string MKTCOST12="MktCost12";
		public const string PRMKTCOST01="PrMktCost01";
		public const string PRMKTCOST02="PrMktCost02";
		public const string PRMKTCOST03="PrMktCost03";
		public const string PRMKTCOST04="PrMktCost04";
		public const string PRMKTCOST05="PrMktCost05";
		public const string PRMKTCOST06="PrMktCost06";
		public const string PRMKTCOST07="PrMktCost07";
		public const string PRMKTCOST08="PrMktCost08";
		public const string PRMKTCOST09="PrMktCost09";
		public const string PRMKTCOST10="PrMktCost10";
		public const string PRMKTCOST11="PrMktCost11";
		public const string PRMKTCOST12="PrMktCost12";
		public const string PRPRMKTCOST01="PrPrMktCost01";
		public const string PRPRMKTCOST02="PrPrMktCost02";
		public const string PRPRMKTCOST03="PrPrMktCost03";
		public const string PRPRMKTCOST04="PrPrMktCost04";
		public const string PRPRMKTCOST05="PrPrMktCost05";
		public const string PRPRMKTCOST06="PrPrMktCost06";
		public const string PRPRMKTCOST07="PrPrMktCost07";
		public const string PRPRMKTCOST08="PrPrMktCost08";
		public const string PRPRMKTCOST09="PrPrMktCost09";
		public const string PRPRMKTCOST10="PrPrMktCost10";
		public const string PRPRMKTCOST11="PrPrMktCost11";
		public const string PRPRMKTCOST12="PrPrMktCost12";
		public const string MKTCOST13="MktCost13";
		*/
		#endregion Not Used Fields
		public const string PRTBRNDESCANDADDRESS="PrtBrnDescAndAddress";
		public const string ADDPULLCARD="AddPullCard";
		public const string POORDNO="PoOrdno";
        public const string PURCHASEORDERFIRSTCHAR = "PurchaseOrderFirstChar";
        public const string SALESORDERFIRSTCHAR = "SalesOrderFirstChar";

        public const string NextJobNo = "NextJobNo";
        

        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

		public MBranchDEL()
		{
			//Create MBranch structure
			CreateMBranchStructure();

		}

		//=========MBranch============================
		private void CreateMBranchStructure()
		{
			DataTable table;
			DataColumnCollection DCC;
			DataColumn DC=new DataColumn();
			table=new DataTable (TABLENAME_MBRANCH);
			DCC=table.Columns;
			
			DC=new DataColumn(RECID,typeof(System.Int32));
			DCC.Add(DC);
			
			DC=new DataColumn(BRANCHNO,typeof(System.String));
			DC.DefaultValue="000";
			DCC.Add(DC);
			
			DC=new DataColumn(BRANCHDESC,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(STINVRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(ENINVRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(NEXTINVNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(STORDRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(ENORDRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(NEXTORDNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(STPURCHORDRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(ENPURCHORDRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(NEXTPURCHORDNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(STWORKORDRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(ENWORKORDRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(NEXTWORKORDNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(INTERBRNACCTNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(INTERBRNPROFITNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(STQUOTRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(ENQUOTRANGE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(NEXTQUOTNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(INVACCTNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(INVPROFITNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);

            DC = new DataColumn(INVACCTNO1, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(INVPROFITNO1, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
			
			#region Not Used Fields
			/*
			DC=new DataColumn(SALES01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(SALES13,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(COST13,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRSALES12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRCOST12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRSALES12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRYRCOST12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCH13,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PURCHDISC13,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCH12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRYRPURCHDISC12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			*/
			#endregion Not Used Fields
			
			DC=new DataColumn(STREET,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(CITY,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(PROVNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(POSTALCODE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(FAX,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(PHONE,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(COMPANYPHONE01,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			DC=new DataColumn(COMPANYPHONE02,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
			
			#region Not Used Fields
			/*
			DC=new DataColumn(MKTCOST01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRMKTCOST12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST01,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST02,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST03,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST04,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST05,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST06,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST07,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST08,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST09,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST10,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST11,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(PRPRMKTCOST12,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			
			DC=new DataColumn(MKTCOST13,typeof(System.Double));
			DC.DefaultValue="0";
			DCC.Add(DC);
			*/
			#endregion Not Used Fields
			
			DC=new DataColumn(PRTBRNDESCANDADDRESS,typeof(System.Boolean));
			DC.DefaultValue="false";
			DCC.Add(DC);
			
			DC=new DataColumn(ADDPULLCARD,typeof(System.Boolean));
			DC.DefaultValue="false";
			DCC.Add(DC);
			
			DC=new DataColumn(POORDNO,typeof(System.String));
			DC.DefaultValue="";
			DCC.Add(DC);
            
            DC = new DataColumn(PURCHASEORDERFIRSTCHAR , typeof(System.String));
            DC.DefaultValue = "";
            DC.MaxLength = 1;
            DCC.Add(DC);

            DC = new DataColumn(SALESORDERFIRSTCHAR, typeof(System.String));
            DC.DefaultValue = "";
            DC.MaxLength = 1;
            DCC.Add(DC);

            DC = new DataColumn(NextJobNo, typeof(System.String));
            DC.DefaultValue = "";
            DC.MaxLength = 5;
            DCC.Add(DC);

			DC=new DataColumn(RECSTAMP,typeof(System.Byte[]));
			DCC.Add(DC);			
			
			this.Tables.Add (table);
		}

	}
}

